Getting this error - I know I'm missing something but can't figure what. I have set up the datasource in application.cfc. Anyone see what I'm missing ? cfset this.datasource = "boi-interview-local" And this is the component which includes the call to the datasource: cfcomponent displayname="BOI" hint="ColdFusion Component for Add Beneficiaries" cffunction name="ProcessCompanyDetails" access="remote" output="true" returntype="string" returnformat="plain" cfquery name="insertCompanyBOIinfo" datasource="#this.datasource#" INSERT INTO dbo.beneficiaries (somename,somealternateName) VALUES( cfqueryparam value="#form.somename#" cfsqltype="CF_SQL_VARCHAR", cfqueryparam value="#form.somealternateName#" cfsqltype="CF_SQL_VARCHAR" ) /cfquery cflocation url="addbeneficiaries.cfm" /cffunction

this.dataSource

in Application.cfc is not the same variable as

this.dataSource

in another CFC. This should not be a surprise

Tried application,dataspurce but says there is no datasource by that name but there is!

application.datasource

was incorrect advice.

😂

Yeah got confused, ignore me

Unless you actively create a variable called that in

onApplicationStart

, but should not need it if you have

this.datasource

set, and that's the only data source you need to use.

so what do I do sorry ?

Reading the docs for the thing you are trying to use would always be a good first step 😉 https://docs.lucee.org/guides/cookbooks/datasource-define-datasource.html But like I said, if you have set a

this.datasource

in Application.cfc, then you don't need to specify it in the

<cfquery>

tag at all.

ah ok cheers @Adam Cameron 🙏